home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Belgian Amiga Club - ADF Collection
/
BS1 part 43.zip
/
Superbase pro 2.1 disk 2.adf
/
clientdeps.sbp
< prev
next >
Wrap
Text File
|
1987-12-09
|
1KB
|
46 lines
OPEN FILE "Clients"
OPEN FILE "Deposits"
REQUEST "REPORT TO PRINTER ?","",1,a%
IF a% THEN PRINT;
REPORT Amount.Deposits
BEFORE REPORT
END REPORT
AFTER REPORT
? ATTR OFF ;@5 "Total Amount";@27 "Highest Deposit";@47 "Smallest Deposit"
? @4 "£";&15 SUM Amount.Deposits;@26 "£";&15 MAX Amount.Deposits;@46 "£";&15 MIN Amount.Deposits
?
END REPORT
HEADING
?
? ATTR OFF ; BF ; UL ;@23 "Clients' Deposits on ";&12 TODAY
?
? BF OFF ; UL OFF ;@2 "Date";@21 "Bank";@40 "Account";@61 "Amount Deposited"
?
END HEADING
GROUP Lastname.Clients,Amount.Deposits
BEFORE GROUP Lastname.Clients
? ATTR OFF ;@3 "Deposits for client"; BF ;@23 Firstname.Clients;Lastname.Clients
?
END GROUP
AFTER GROUP Lastname.Clients
?
? ATTR OFF ;@20 "Total deposit for";@38 &21 GROUP ;@61 "£";&15 SUM Amount.Deposits
?
END GROUP
GROUP Date.Deposits
BEFORE GROUP Date.Deposits
END GROUP
AFTER GROUP Date.Deposits
END GROUP
SELECT ATTR OFF ;Date.Deposits;@20 Bank.Deposits;@40 Account.Deposits;@61 Amount.Deposits
WHERE Lastname.Deposits = Lastname.Clients ASK
ORDER Lastname.Clients,Date.Deposits ASK